Overview

Brought to you by YData

Dataset statistics

Number of variables	32
Number of observations	15319
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	1081
Duplicate rows (%)	7.1%
Total size in memory	13.5 MiB
Average record size in memory	927.1 B

Variable types

Categorical	18
Numeric	12
Text	1
DateTime	1

Alerts

`hotel` has constant value "City Hotel"	Constant
`is_canceled` has constant value "1"	Constant
`arrival_date_year` has constant value "2016"	Constant
`required_car_parking_spaces` has constant value "0"	Constant
Dataset has 1081 (7.1%) duplicate rows	Duplicates
`arrival_date_month` is highly overall correlated with `arrival_date_week_number`	High correlation
`arrival_date_week_number` is highly overall correlated with `arrival_date_month`	High correlation
`assigned_room_type` is highly overall correlated with `reserved_room_type`	High correlation
`cancellation_ratio` is highly overall correlated with `previous_cancellations`	High correlation
`deposit_type` is highly overall correlated with `market_segment`	High correlation
`distribution_channel` is highly overall correlated with `market_segment`	High correlation
`market_segment` is highly overall correlated with `deposit_type` and 1 other fields	High correlation
`previous_cancellations` is highly overall correlated with `cancellation_ratio`	High correlation
`reserved_room_type` is highly overall correlated with `assigned_room_type`	High correlation
`stays_in_week_nights` is highly overall correlated with `total_stay`	High correlation
`stays_in_weekend_nights` is highly overall correlated with `total_stay`	High correlation
`total_stay` is highly overall correlated with `stays_in_week_nights` and 1 other fields	High correlation
`adults` is highly imbalanced (56.7%)	Imbalance
`children` is highly imbalanced (79.9%)	Imbalance
`babies` is highly imbalanced (97.8%)	Imbalance
`distribution_channel` is highly imbalanced (80.5%)	Imbalance
`is_repeated_guest` is highly imbalanced (96.0%)	Imbalance
`reserved_room_type` is highly imbalanced (66.3%)	Imbalance
`assigned_room_type` is highly imbalanced (66.2%)	Imbalance
`customer_type` is highly imbalanced (72.2%)	Imbalance
`total_of_special_requests` is highly imbalanced (63.0%)	Imbalance
`reservation_status` is highly imbalanced (77.9%)	Imbalance
`previous_bookings_not_canceled` is highly skewed (γ1 = 36.26197166)	Skewed
`stays_in_weekend_nights` has 7804 (50.9%) zeros	Zeros
`stays_in_week_nights` has 769 (5.0%) zeros	Zeros
`previous_cancellations` has 14020 (91.5%) zeros	Zeros
`previous_bookings_not_canceled` has 15255 (99.6%) zeros	Zeros
`booking_changes` has 14471 (94.5%) zeros	Zeros
`days_in_waiting_list` has 13243 (86.4%) zeros	Zeros
`cancellation_ratio` has 14020 (91.5%) zeros	Zeros

Reproduction

Analysis started	2025-01-24 19:09:24.340285
Analysis finished	2025-01-24 19:09:57.284683
Duration	32.94 seconds
Software version	ydata-profiling vv4.12.2
Download configuration	config.json

hotel
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

City Hotel	15319

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	153190
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	City Hotel
2nd row	City Hotel
3rd row	City Hotel
4th row	City Hotel
5th row	City Hotel

Common Values

Value	Count	Frequency (%)
City Hotel	15319	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
city	15319	50.0%
hotel	15319	50.0%

Most occurring characters

Value	Count	Frequency (%)
t	30638	20.0%
C	15319	10.0%
i	15319	10.0%
y	15319	10.0%
	15319	10.0%
H	15319	10.0%
o	15319	10.0%
e	15319	10.0%
l	15319	10.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	153190	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	30638	20.0%
C	15319	10.0%
i	15319	10.0%
y	15319	10.0%
	15319	10.0%
H	15319	10.0%
o	15319	10.0%
e	15319	10.0%
l	15319	10.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	153190	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	30638	20.0%
C	15319	10.0%
i	15319	10.0%
y	15319	10.0%
	15319	10.0%
H	15319	10.0%
o	15319	10.0%
e	15319	10.0%
l	15319	10.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	153190	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	30638	20.0%
C	15319	10.0%
i	15319	10.0%
y	15319	10.0%
	15319	10.0%
H	15319	10.0%
o	15319	10.0%
e	15319	10.0%
l	15319	10.0%

is_canceled
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	987.4 KiB

1	15319

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	15319
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	15319	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	15319	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	15319	100.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	15319	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	15319	100.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	15319	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	15319	100.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	15319	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	15319	100.0%

lead_time
Real number (ℝ)

Distinct	383
Distinct (%)	2.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	150.12932

Minimum	0
Maximum	626
Zeros	107
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	239.4 KiB

Quantile statistics

Minimum	0
5-th percentile	9
Q1	48
median	113
Q3	230
95-th percentile	412
Maximum	626
Range	626
Interquartile range (IQR)	182

Descriptive statistics

Standard deviation	126.07863
Coefficient of variation (CV)	0.83980021
Kurtosis	0.43692289
Mean	150.12932
Median Absolute Deviation (MAD)	77
Skewness	1.0054371
Sum	2299831
Variance	15895.821
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
68	200	1.3%
37	196	1.3%
277	187	1.2%
71	144	0.9%
56	141	0.9%
1	135	0.9%
188	132	0.9%
113	118	0.8%
158	117	0.8%
44	116	0.8%
Other values (373)	13833	90.3%

Value	Count	Frequency (%)
0	107	0.7%
1	135	0.9%
2	69	0.5%
3	57	0.4%
4	77	0.5%
5	82	0.5%
6	71	0.5%
7	69	0.5%
8	76	0.5%
9	75	0.5%

Value	Count	Frequency (%)
626	30	0.2%
605	30	0.2%
538	17	0.1%
531	17	0.1%
524	17	0.1%
517	17	0.1%
510	17	0.1%
503	17	0.1%
496	17	0.1%
489	17	0.1%

arrival_date_year
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

2016	15319

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	61276
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2016
2nd row	2016
3rd row	2016
4th row	2016
5th row	2016

Common Values

Value	Count	Frequency (%)
2016	15319	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2016	15319	100.0%

Most occurring characters

Value	Count	Frequency (%)
2	15319	25.0%
0	15319	25.0%
1	15319	25.0%
6	15319	25.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	61276	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	15319	25.0%
0	15319	25.0%
1	15319	25.0%
6	15319	25.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	61276	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	15319	25.0%
0	15319	25.0%
1	15319	25.0%
6	15319	25.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	61276	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	15319	25.0%
0	15319	25.0%
1	15319	25.0%
6	15319	25.0%

arrival_date_month
Categorical

High correlation

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

October	1944
June	1716
September	1561
April	1526
May	1433
Other values (7)	7139

Length

Max length	9
Median length	7
Mean length	6.0847314
Min length	3

Characters and Unicode

Total characters	93212
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	April
2nd row	March
3rd row	April
4th row	January
5th row	April

Common Values

Value	Count	Frequency (%)
October	1944	12.7%
June	1716	11.2%
September	1561	10.2%
April	1526	10.0%
May	1433	9.4%
November	1354	8.8%
August	1244	8.1%
March	1098	7.2%
December	1064	6.9%
July	1034	6.7%
Other values (2)	1345	8.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
october	1944	12.7%
june	1716	11.2%
september	1561	10.2%
april	1526	10.0%
may	1433	9.4%
november	1354	8.8%
august	1244	8.1%
march	1098	7.2%
december	1064	6.9%
july	1034	6.7%
Other values (2)	1345	8.8%

Most occurring characters

Value	Count	Frequency (%)
e	15156	16.3%
r	10805	11.6%
b	6836	7.3%
u	6583	7.1%
t	4749	5.1%
a	4308	4.6%
c	4106	4.4%
m	3979	4.3%
y	3812	4.1%
o	3298	3.5%
Other values (16)	29580	31.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	93212	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	15156	16.3%
r	10805	11.6%
b	6836	7.3%
u	6583	7.1%
t	4749	5.1%
a	4308	4.6%
c	4106	4.4%
m	3979	4.3%
y	3812	4.1%
o	3298	3.5%
Other values (16)	29580	31.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	93212	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	15156	16.3%
r	10805	11.6%
b	6836	7.3%
u	6583	7.1%
t	4749	5.1%
a	4308	4.6%
c	4106	4.4%
m	3979	4.3%
y	3812	4.1%
o	3298	3.5%
Other values (16)	29580	31.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	93212	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	15156	16.3%
r	10805	11.6%
b	6836	7.3%
u	6583	7.1%
t	4749	5.1%
a	4308	4.6%
c	4106	4.4%
m	3979	4.3%
y	3812	4.1%
o	3298	3.5%
Other values (16)	29580	31.7%

arrival_date_week_number
Real number (ℝ)

High correlation

Distinct	53
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	29.509759

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	239.4 KiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	18
median	29
Q3	42
95-th percentile	50
Maximum	53
Range	52
Interquartile range (IQR)	24

Descriptive statistics

Standard deviation	13.52747
Coefficient of variation (CV)	0.45840666
Kurtosis	-1.1294326
Mean	29.509759
Median Absolute Deviation (MAD)	12
Skewness	-0.092294368
Sum	452060
Variance	182.99245
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
25	622	4.1%
42	539	3.5%
45	537	3.5%
43	473	3.1%
40	468	3.1%
13	428	2.8%
23	398	2.6%
17	393	2.6%
18	390	2.5%
24	387	2.5%
Other values (43)	10684	69.7%

Value	Count	Frequency (%)
1	40	0.3%
2	35	0.2%
3	64	0.4%
4	145	0.9%
5	146	1.0%
6	85	0.6%
7	115	0.8%
8	353	2.3%
9	206	1.3%
10	292	1.9%

Value	Count	Frequency (%)
53	323	2.1%
52	148	1.0%
51	150	1.0%
50	249	1.6%
49	294	1.9%
48	194	1.3%
47	232	1.5%
46	381	2.5%
45	537	3.5%
44	368	2.4%

arrival_date_day_of_month
Real number (ℝ)

Distinct	31
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.841308

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	239.4 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.8123628
Coefficient of variation (CV)	0.55629009
Kurtosis	-1.1757675
Mean	15.841308
Median Absolute Deviation (MAD)	8
Skewness	-0.021321698
Sum	242673
Variance	77.657737
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
17	750	4.9%
28	692	4.5%
7	645	4.2%
20	636	4.2%
19	570	3.7%
13	566	3.7%
1	556	3.6%
15	552	3.6%
22	526	3.4%
27	525	3.4%
Other values (21)	9301	60.7%

Value	Count	Frequency (%)
1	556	3.6%
2	504	3.3%
3	457	3.0%
4	509	3.3%
5	483	3.2%
6	428	2.8%
7	645	4.2%
8	487	3.2%
9	477	3.1%
10	334	2.2%

Value	Count	Frequency (%)
31	221	1.4%
30	524	3.4%
29	465	3.0%
28	692	4.5%
27	525	3.4%
26	485	3.2%
25	425	2.8%
24	482	3.1%
23	295	1.9%
22	526	3.4%

stays_in_weekend_nights
Real number (ℝ)

High correlation Zeros

Distinct	10
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.75207259

Minimum	0
Maximum	9
Zeros	7804
Zeros (%)	50.9%
Negative	0
Negative (%)	0.0%
Memory size	239.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	2
Maximum	9
Range	9
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.91947534
Coefficient of variation (CV)	1.2225885
Kurtosis	5.3833554
Mean	0.75207259
Median Absolute Deviation (MAD)	0
Skewness	1.5230743
Sum	11521
Variance	0.84543489
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	7804	50.9%
1	4020	26.2%
2	3265	21.3%
4	99	0.6%
3	76	0.5%
6	21	0.1%
5	16	0.1%
8	11	0.1%
7	5	< 0.1%
9	2	< 0.1%

Value	Count	Frequency (%)
0	7804	50.9%
1	4020	26.2%
2	3265	21.3%
3	76	0.5%
4	99	0.6%
5	16	0.1%
6	21	0.1%
7	5	< 0.1%
8	11	0.1%
9	2	< 0.1%

Value	Count	Frequency (%)
9	2	< 0.1%
8	11	0.1%
7	5	< 0.1%
6	21	0.1%
5	16	0.1%
4	99	0.6%
3	76	0.5%
2	3265	21.3%
1	4020	26.2%
0	7804	50.9%

stays_in_week_nights
Real number (ℝ)

High correlation Zeros

Distinct	23
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.3156211

Minimum	0
Maximum	22
Zeros	769
Zeros (%)	5.0%
Negative	0
Negative (%)	0.0%
Memory size	239.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	3
95-th percentile	5
Maximum	22
Range	22
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.5800644
Coefficient of variation (CV)	0.68235013
Kurtosis	28.269022
Mean	2.3156211
Median Absolute Deviation (MAD)	1
Skewness	3.5051945
Sum	35473
Variance	2.4966035
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
2	6058	39.5%
1	3243	21.2%
3	3112	20.3%
4	1171	7.6%
0	769	5.0%
5	652	4.3%
6	91	0.6%
7	53	0.3%
10	51	0.3%
8	33	0.2%
Other values (13)	86	0.6%

Value	Count	Frequency (%)
0	769	5.0%
1	3243	21.2%
2	6058	39.5%
3	3112	20.3%
4	1171	7.6%
5	652	4.3%
6	91	0.6%
7	53	0.3%
8	33	0.2%
9	29	0.2%

Value	Count	Frequency (%)
22	3	< 0.1%
21	6	< 0.1%
20	4	< 0.1%
19	2	< 0.1%
18	4	< 0.1%
17	2	< 0.1%
16	2	< 0.1%
15	7	< 0.1%
14	7	< 0.1%
13	3	< 0.1%

adults
Categorical

Imbalance

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	987.4 KiB

2	11634
1	2805
3	835
0	42
4	3

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	15319
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	2
3rd row	3
4th row	1
5th row	2

Common Values

Value	Count	Frequency (%)
2	11634	75.9%
1	2805	18.3%
3	835	5.5%
0	42	0.3%
4	3	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	11634	75.9%
1	2805	18.3%
3	835	5.5%
0	42	0.3%
4	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
2	11634	75.9%
1	2805	18.3%
3	835	5.5%
0	42	0.3%
4	3	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	15319	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	11634	75.9%
1	2805	18.3%
3	835	5.5%
0	42	0.3%
4	3	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	15319	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	11634	75.9%
1	2805	18.3%
3	835	5.5%
0	42	0.3%
4	3	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	15319	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	11634	75.9%
1	2805	18.3%
3	835	5.5%
0	42	0.3%
4	3	< 0.1%

children
Categorical

Imbalance

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	987.4 KiB

0	14363
1	521
2	430
3	5

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	15319
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	14363	93.8%
1	521	3.4%
2	430	2.8%
3	5	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	14363	93.8%
1	521	3.4%
2	430	2.8%
3	5	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	14363	93.8%
1	521	3.4%
2	430	2.8%
3	5	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	15319	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	14363	93.8%
1	521	3.4%
2	430	2.8%
3	5	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	15319	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	14363	93.8%
1	521	3.4%
2	430	2.8%
3	5	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	15319	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	14363	93.8%
1	521	3.4%
2	430	2.8%
3	5	< 0.1%

babies
Categorical

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	987.4 KiB

0	15287
1	32

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	15319
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	15287	99.8%
1	32	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	15287	99.8%
1	32	0.2%

Most occurring characters

Value	Count	Frequency (%)
0	15287	99.8%
1	32	0.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	15319	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	15287	99.8%
1	32	0.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	15319	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	15287	99.8%
1	32	0.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	15319	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	15287	99.8%
1	32	0.2%

meal
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1002.3 KiB

BB	12539
SC	1872
HB	908

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	30638
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	BB
2nd row	BB
3rd row	BB
4th row	BB
5th row	BB

Common Values

Value	Count	Frequency (%)
BB	12539	81.9%
SC	1872	12.2%
HB	908	5.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
bb	12539	81.9%
sc	1872	12.2%
hb	908	5.9%

Most occurring characters

Value	Count	Frequency (%)
B	25986	84.8%
S	1872	6.1%
C	1872	6.1%
H	908	3.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	30638	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
B	25986	84.8%
S	1872	6.1%
C	1872	6.1%
H	908	3.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	30638	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
B	25986	84.8%
S	1872	6.1%
C	1872	6.1%
H	908	3.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	30638	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
B	25986	84.8%
S	1872	6.1%
C	1872	6.1%
H	908	3.0%

country
Text

Distinct	113
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	1017.2 KiB

Length

Max length	3
Median length	3
Mean length	2.9955611
Min length	2

Characters and Unicode

Total characters	45889
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	19 ?
Unique (%)	0.1%

Sample

1st row	PRT
2nd row	PRT
3rd row	PRT
4th row	PRT
5th row	FRA

Value	Count	Frequency (%)
prt	8727	57.0%
fra	830	5.4%
esp	825	5.4%
gbr	718	4.7%
ita	634	4.1%
deu	522	3.4%
bra	335	2.2%
chn	248	1.6%
irl	191	1.2%
bel	190	1.2%
Other values (103)	2099	13.7%

Most occurring characters

Value	Count	Frequency (%)
R	11339	24.7%
P	9715	21.2%
T	9567	20.8%
A	2408	5.2%
E	1864	4.1%
S	1387	3.0%
B	1277	2.8%
U	1168	2.5%
I	1011	2.2%
G	965	2.1%
Other values (16)	5188	11.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	45889	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
R	11339	24.7%
P	9715	21.2%
T	9567	20.8%
A	2408	5.2%
E	1864	4.1%
S	1387	3.0%
B	1277	2.8%
U	1168	2.5%
I	1011	2.2%
G	965	2.1%
Other values (16)	5188	11.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	45889	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
R	11339	24.7%
P	9715	21.2%
T	9567	20.8%
A	2408	5.2%
E	1864	4.1%
S	1387	3.0%
B	1277	2.8%
U	1168	2.5%
I	1011	2.2%
G	965	2.1%
Other values (16)	5188	11.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	45889	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
R	11339	24.7%
P	9715	21.2%
T	9567	20.8%
A	2408	5.2%
E	1864	4.1%
S	1387	3.0%
B	1277	2.8%
U	1168	2.5%
I	1011	2.2%
G	965	2.1%
Other values (16)	5188	11.3%

market_segment
Categorical

High correlation

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Online TA	7131
Offline TA/TO	3887
Groups	3488
Direct	496
Corporate	288

Length

Max length	13
Median length	9
Mean length	9.2328481
Min length	6

Characters and Unicode

Total characters	141438
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Offline TA/TO
2nd row	Offline TA/TO
3rd row	Offline TA/TO
4th row	Offline TA/TO
5th row	Online TA

Common Values

Value	Count	Frequency (%)
Online TA	7131	46.6%
Offline TA/TO	3887	25.4%
Groups	3488	22.8%
Direct	496	3.2%
Corporate	288	1.9%
Aviation	29	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
online	7131	27.1%
ta	7131	27.1%
offline	3887	14.8%
ta/to	3887	14.8%
groups	3488	13.2%
direct	496	1.9%
corporate	288	1.1%
aviation	29	0.1%

Most occurring characters

Value	Count	Frequency (%)
n	18178	12.9%
O	14905	10.5%
T	14905	10.5%
e	11802	8.3%
i	11572	8.2%
A	11047	7.8%
l	11018	7.8%
	11018	7.8%
f	7774	5.5%
r	4560	3.2%
Other values (12)	24659	17.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	141438	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	18178	12.9%
O	14905	10.5%
T	14905	10.5%
e	11802	8.3%
i	11572	8.2%
A	11047	7.8%
l	11018	7.8%
	11018	7.8%
f	7774	5.5%
r	4560	3.2%
Other values (12)	24659	17.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	141438	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	18178	12.9%
O	14905	10.5%
T	14905	10.5%
e	11802	8.3%
i	11572	8.2%
A	11047	7.8%
l	11018	7.8%
	11018	7.8%
f	7774	5.5%
r	4560	3.2%
Other values (12)	24659	17.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	141438	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	18178	12.9%
O	14905	10.5%
T	14905	10.5%
e	11802	8.3%
i	11572	8.2%
A	11047	7.8%
l	11018	7.8%
	11018	7.8%
f	7774	5.5%
r	4560	3.2%
Other values (12)	24659	17.4%

distribution_channel
Categorical

High correlation Imbalance

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

TA/TO	14412
Direct	508
Corporate	377
GDS	22

Length

Max length	9
Median length	5
Mean length	5.128729
Min length	3

Characters and Unicode

Total characters	78567
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	TA/TO
2nd row	TA/TO
3rd row	TA/TO
4th row	TA/TO
5th row	TA/TO

Common Values

Value	Count	Frequency (%)
TA/TO	14412	94.1%
Direct	508	3.3%
Corporate	377	2.5%
GDS	22	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ta/to	14412	94.1%
direct	508	3.3%
corporate	377	2.5%
gds	22	0.1%

Most occurring characters

Value	Count	Frequency (%)
T	28824	36.7%
A	14412	18.3%
/	14412	18.3%
O	14412	18.3%
r	1262	1.6%
e	885	1.1%
t	885	1.1%
o	754	1.0%
D	530	0.7%
i	508	0.6%
Other values (6)	1683	2.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	78567	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
T	28824	36.7%
A	14412	18.3%
/	14412	18.3%
O	14412	18.3%
r	1262	1.6%
e	885	1.1%
t	885	1.1%
o	754	1.0%
D	530	0.7%
i	508	0.6%
Other values (6)	1683	2.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	78567	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
T	28824	36.7%
A	14412	18.3%
/	14412	18.3%
O	14412	18.3%
r	1262	1.6%
e	885	1.1%
t	885	1.1%
o	754	1.0%
D	530	0.7%
i	508	0.6%
Other values (6)	1683	2.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	78567	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
T	28824	36.7%
A	14412	18.3%
/	14412	18.3%
O	14412	18.3%
r	1262	1.6%
e	885	1.1%
t	885	1.1%
o	754	1.0%
D	530	0.7%
i	508	0.6%
Other values (6)	1683	2.1%

is_repeated_guest
Categorical

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	987.4 KiB

0	15254
1	65

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	15319
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	15254	99.6%
1	65	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	15254	99.6%
1	65	0.4%

Most occurring characters

Value	Count	Frequency (%)
0	15254	99.6%
1	65	0.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	15319	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	15254	99.6%
1	65	0.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	15319	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	15254	99.6%
1	65	0.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	15319	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	15254	99.6%
1	65	0.4%

previous_cancellations
Real number (ℝ)

High correlation Zeros

Distinct	8
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.10118154

Minimum	0
Maximum	13
Zeros	14020
Zeros (%)	91.5%
Negative	0
Negative (%)	0.0%
Memory size	239.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	13
Range	13
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.51692649
Coefficient of variation (CV)	5.1089012
Kurtosis	362.73566
Mean	0.10118154
Median Absolute Deviation (MAD)	0
Skewness	16.25535
Sum	1550
Variance	0.26721299
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
0	14020	91.5%
1	1264	8.3%
13	10	0.1%
11	8	0.1%
6	7	< 0.1%
2	6	< 0.1%
3	3	< 0.1%
5	1	< 0.1%

Value	Count	Frequency (%)
0	14020	91.5%
1	1264	8.3%
2	6	< 0.1%
3	3	< 0.1%
5	1	< 0.1%
6	7	< 0.1%
11	8	0.1%
13	10	0.1%

Value	Count	Frequency (%)
13	10	0.1%
11	8	0.1%
6	7	< 0.1%
5	1	< 0.1%
3	3	< 0.1%
2	6	< 0.1%
1	1264	8.3%
0	14020	91.5%

previous_bookings_not_canceled
Real number (ℝ)

Skewed Zeros

Distinct	18
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.039689275

Minimum	0
Maximum	58
Zeros	15255
Zeros (%)	99.6%
Negative	0
Negative (%)	0.0%
Memory size	239.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	58
Range	58
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.0103224
Coefficient of variation (CV)	25.455804
Kurtosis	1552.1768
Mean	0.039689275
Median Absolute Deviation (MAD)	0
Skewness	36.261972
Sum	608
Variance	1.0207513
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
0	15255	99.6%
1	21	0.1%
25	8	0.1%
4	6	< 0.1%
5	6	< 0.1%
3	4	< 0.1%
2	3	< 0.1%
6	3	< 0.1%
12	3	< 0.1%
11	2	< 0.1%
Other values (8)	8	0.1%

Value	Count	Frequency (%)
0	15255	99.6%
1	21	0.1%
2	3	< 0.1%
3	4	< 0.1%
4	6	< 0.1%
5	6	< 0.1%
6	3	< 0.1%
8	1	< 0.1%
10	1	< 0.1%
11	2	< 0.1%

Value	Count	Frequency (%)
58	1	< 0.1%
48	1	< 0.1%
44	1	< 0.1%
29	1	< 0.1%
27	1	< 0.1%
25	8	0.1%
15	1	< 0.1%
12	3	< 0.1%
11	2	< 0.1%
10	1	< 0.1%

reserved_room_type
Categorical

High correlation Imbalance

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	987.4 KiB

A	12414
D	2130
F	377
B	204
E	147
Other values (2)	47

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	15319
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	D
2nd row	A
3rd row	A
4th row	A
5th row	D

Common Values

Value	Count	Frequency (%)
A	12414	81.0%
D	2130	13.9%
F	377	2.5%
B	204	1.3%
E	147	1.0%
G	43	0.3%
C	4	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
a	12414	81.0%
d	2130	13.9%
f	377	2.5%
b	204	1.3%
e	147	1.0%
g	43	0.3%
c	4	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
A	12414	81.0%
D	2130	13.9%
F	377	2.5%
B	204	1.3%
E	147	1.0%
G	43	0.3%
C	4	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	15319	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	12414	81.0%
D	2130	13.9%
F	377	2.5%
B	204	1.3%
E	147	1.0%
G	43	0.3%
C	4	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	15319	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	12414	81.0%
D	2130	13.9%
F	377	2.5%
B	204	1.3%
E	147	1.0%
G	43	0.3%
C	4	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	15319	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	12414	81.0%
D	2130	13.9%
F	377	2.5%
B	204	1.3%
E	147	1.0%
G	43	0.3%
C	4	< 0.1%

assigned_room_type
Categorical

High correlation Imbalance

Distinct	8
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	987.4 KiB

A	12218
D	2188
F	385
B	293
E	172
Other values (3)	63

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	15319
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	D
2nd row	A
3rd row	B
4th row	A
5th row	D

Common Values

Value	Count	Frequency (%)
A	12218	79.8%
D	2188	14.3%
F	385	2.5%
B	293	1.9%
E	172	1.1%
G	46	0.3%
C	11	0.1%
K	6	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
a	12218	79.8%
d	2188	14.3%
f	385	2.5%
b	293	1.9%
e	172	1.1%
g	46	0.3%
c	11	0.1%
k	6	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
A	12218	79.8%
D	2188	14.3%
F	385	2.5%
B	293	1.9%
E	172	1.1%
G	46	0.3%
C	11	0.1%
K	6	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	15319	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	12218	79.8%
D	2188	14.3%
F	385	2.5%
B	293	1.9%
E	172	1.1%
G	46	0.3%
C	11	0.1%
K	6	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	15319	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	12218	79.8%
D	2188	14.3%
F	385	2.5%
B	293	1.9%
E	172	1.1%
G	46	0.3%
C	11	0.1%
K	6	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	15319	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	12218	79.8%
D	2188	14.3%
F	385	2.5%
B	293	1.9%
E	172	1.1%
G	46	0.3%
C	11	0.1%
K	6	< 0.1%

booking_changes
Real number (ℝ)

Zeros

Distinct	11
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.089039755

Minimum	0
Maximum	14
Zeros	14471
Zeros (%)	94.5%
Negative	0
Negative (%)	0.0%
Memory size	239.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	14
Range	14
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.44244022
Coefficient of variation (CV)	4.9690189
Kurtosis	123.29283
Mean	0.089039755
Median Absolute Deviation (MAD)	0
Skewness	8.3273029
Sum	1364
Variance	0.19575335
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0	14471	94.5%
1	502	3.3%
2	256	1.7%
3	52	0.3%
4	20	0.1%
5	8	0.1%
6	6	< 0.1%
7	1	< 0.1%
9	1	< 0.1%
14	1	< 0.1%

Value	Count	Frequency (%)
0	14471	94.5%
1	502	3.3%
2	256	1.7%
3	52	0.3%
4	20	0.1%
5	8	0.1%
6	6	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
14	1	< 0.1%
9	1	< 0.1%
8	1	< 0.1%
7	1	< 0.1%
6	6	< 0.1%
5	8	0.1%
4	20	0.1%
3	52	0.3%
2	256	1.7%
1	502	3.3%

deposit_type
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

No Deposit	9434
Non Refund	5884
Refundable	1

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	153190
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	No Deposit
2nd row	No Deposit
3rd row	No Deposit
4th row	No Deposit
5th row	No Deposit

Common Values

Value	Count	Frequency (%)
No Deposit	9434	61.6%
Non Refund	5884	38.4%
Refundable	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	9434	30.8%
deposit	9434	30.8%
non	5884	19.2%
refund	5884	19.2%
refundable	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
o	24752	16.2%
e	15320	10.0%
N	15318	10.0%
	15318	10.0%
n	11769	7.7%
i	9434	6.2%
t	9434	6.2%
s	9434	6.2%
p	9434	6.2%
D	9434	6.2%
Other values (7)	23543	15.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	153190	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	24752	16.2%
e	15320	10.0%
N	15318	10.0%
	15318	10.0%
n	11769	7.7%
i	9434	6.2%
t	9434	6.2%
s	9434	6.2%
p	9434	6.2%
D	9434	6.2%
Other values (7)	23543	15.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	153190	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	24752	16.2%
e	15320	10.0%
N	15318	10.0%
	15318	10.0%
n	11769	7.7%
i	9434	6.2%
t	9434	6.2%
s	9434	6.2%
p	9434	6.2%
D	9434	6.2%
Other values (7)	23543	15.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	153190	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	24752	16.2%
e	15320	10.0%
N	15318	10.0%
	15318	10.0%
n	11769	7.7%
i	9434	6.2%
t	9434	6.2%
s	9434	6.2%
p	9434	6.2%
D	9434	6.2%
Other values (7)	23543	15.4%

days_in_waiting_list
Real number (ℝ)

Zeros

Distinct	74
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.1874143

Minimum	0
Maximum	391
Zeros	13243
Zeros (%)	86.4%
Negative	0
Negative (%)	0.0%
Memory size	239.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	55
Maximum	391
Range	391
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	34.640895
Coefficient of variation (CV)	3.7704727
Kurtosis	57.981462
Mean	9.1874143
Median Absolute Deviation (MAD)	0
Skewness	6.6773851
Sum	140742
Variance	1199.9916
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	13243	86.4%
39	225	1.5%
31	122	0.8%
44	108	0.7%
35	93	0.6%
46	87	0.6%
45	65	0.4%
41	63	0.4%
62	60	0.4%
3	59	0.4%
Other values (64)	1194	7.8%

Value	Count	Frequency (%)
0	13243	86.4%
1	2	< 0.1%
3	59	0.4%
4	7	< 0.1%
5	1	< 0.1%
8	4	< 0.1%
9	12	0.1%
10	26	0.2%
11	2	< 0.1%
14	1	< 0.1%

Value	Count	Frequency (%)
391	45	0.3%
379	9	0.1%
330	1	< 0.1%
236	6	< 0.1%
224	6	< 0.1%
223	25	0.2%
215	13	0.1%
207	5	< 0.1%
193	1	< 0.1%
187	23	0.2%

customer_type
Categorical

Imbalance

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Transient	13538
Transient-Party	1685
Contract	89
Group	7

Length

Max length	15
Median length	9
Mean length	9.6523272
Min length	5

Characters and Unicode

Total characters	147864
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Transient
2nd row	Transient
3rd row	Transient
4th row	Transient
5th row	Transient-Party

Common Values

Value	Count	Frequency (%)
Transient	13538	88.4%
Transient-Party	1685	11.0%
Contract	89	0.6%
Group	7	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
transient	13538	88.4%
transient-party	1685	11.0%
contract	89	0.6%
group	7	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
n	30535	20.7%
t	17086	11.6%
r	17004	11.5%
a	16997	11.5%
T	15223	10.3%
s	15223	10.3%
i	15223	10.3%
e	15223	10.3%
y	1685	1.1%
-	1685	1.1%
Other values (7)	1980	1.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	147864	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	30535	20.7%
t	17086	11.6%
r	17004	11.5%
a	16997	11.5%
T	15223	10.3%
s	15223	10.3%
i	15223	10.3%
e	15223	10.3%
y	1685	1.1%
-	1685	1.1%
Other values (7)	1980	1.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	147864	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	30535	20.7%
t	17086	11.6%
r	17004	11.5%
a	16997	11.5%
T	15223	10.3%
s	15223	10.3%
i	15223	10.3%
e	15223	10.3%
y	1685	1.1%
-	1685	1.1%
Other values (7)	1980	1.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	147864	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	30535	20.7%
t	17086	11.6%
r	17004	11.5%
a	16997	11.5%
T	15223	10.3%
s	15223	10.3%
i	15223	10.3%
e	15223	10.3%
y	1685	1.1%
-	1685	1.1%
Other values (7)	1980	1.3%

adr
Real number (ℝ)

Distinct	1746
Distinct (%)	11.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	102.82577

Minimum	26.35
Maximum	306
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	239.4 KiB

Quantile statistics

Minimum	26.35
5-th percentile	62
Q1	76.5
median	99.45
Q3	120
95-th percentile	160
Maximum	306
Range	279.65
Interquartile range (IQR)	43.5

Descriptive statistics

Standard deviation	32.840409
Coefficient of variation (CV)	0.31937917
Kurtosis	2.0607109
Mean	102.82577
Median Absolute Deviation (MAD)	21.55
Skewness	1.0801404
Sum	1575188
Variance	1078.4925
Monotonicity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
62	939	6.1%
75	788	5.1%
120	563	3.7%
100	508	3.3%
65	464	3.0%
110	450	2.9%
130	408	2.7%
90	357	2.3%
80	352	2.3%
95	299	2.0%
Other values (1736)	10191	66.5%

Value	Count	Frequency (%)
26.35	1	< 0.1%
38.67	1	< 0.1%
41.76	1	< 0.1%
43	1	< 0.1%
44.6	1	< 0.1%
45	4	< 0.1%
47.43	2	< 0.1%
47.67	1	< 0.1%
48.5	1	< 0.1%
48.6	1	< 0.1%

Value	Count	Frequency (%)
306	1	< 0.1%
299.33	1	< 0.1%
294	1	< 0.1%
288	1	< 0.1%
285.17	2	< 0.1%
284.1	1	< 0.1%
283	1	< 0.1%
279.2	1	< 0.1%
278.9	1	< 0.1%
277.5	1	< 0.1%

required_car_parking_spaces
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	987.4 KiB

0	15319

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	15319
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	15319	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	15319	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	15319	100.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	15319	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	15319	100.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	15319	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	15319	100.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	15319	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	15319	100.0%

total_of_special_requests
Categorical

Imbalance

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	987.4 KiB

0	12607
1	1951
2	645
3	106
4	10

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	15319
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	1
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	12607	82.3%
1	1951	12.7%
2	645	4.2%
3	106	0.7%
4	10	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	12607	82.3%
1	1951	12.7%
2	645	4.2%
3	106	0.7%
4	10	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	12607	82.3%
1	1951	12.7%
2	645	4.2%
3	106	0.7%
4	10	0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	15319	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	12607	82.3%
1	1951	12.7%
2	645	4.2%
3	106	0.7%
4	10	0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	15319	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	12607	82.3%
1	1951	12.7%
2	645	4.2%
3	106	0.7%
4	10	0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	15319	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	12607	82.3%
1	1951	12.7%
2	645	4.2%
3	106	0.7%
4	10	0.1%

reservation_status
Categorical

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Canceled	14775
No-Show	544

Length

Max length	8
Median length	8
Mean length	7.9644885
Min length	7

Characters and Unicode

Total characters	122008
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Canceled
2nd row	No-Show
3rd row	No-Show
4th row	No-Show
5th row	Canceled

Common Values

Value	Count	Frequency (%)
Canceled	14775	96.4%
No-Show	544	3.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
canceled	14775	96.4%
no-show	544	3.6%

Most occurring characters

Value	Count	Frequency (%)
e	29550	24.2%
C	14775	12.1%
a	14775	12.1%
n	14775	12.1%
c	14775	12.1%
l	14775	12.1%
d	14775	12.1%
o	1088	0.9%
N	544	0.4%
-	544	0.4%
Other values (3)	1632	1.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	122008	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	29550	24.2%
C	14775	12.1%
a	14775	12.1%
n	14775	12.1%
c	14775	12.1%
l	14775	12.1%
d	14775	12.1%
o	1088	0.9%
N	544	0.4%
-	544	0.4%
Other values (3)	1632	1.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	122008	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	29550	24.2%
C	14775	12.1%
a	14775	12.1%
n	14775	12.1%
c	14775	12.1%
l	14775	12.1%
d	14775	12.1%
o	1088	0.9%
N	544	0.4%
-	544	0.4%
Other values (3)	1632	1.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	122008	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	29550	24.2%
C	14775	12.1%
a	14775	12.1%
n	14775	12.1%
c	14775	12.1%
l	14775	12.1%
d	14775	12.1%
o	1088	0.9%
N	544	0.4%
-	544	0.4%
Other values (3)	1632	1.3%

reservation_status_date
Date

Distinct	429
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Memory size	239.4 KiB

Minimum	2015-01-12 00:00:00
Maximum	2016-12-31 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

total_stay
Real number (ℝ)

High correlation

Distinct	30
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.0676937

Minimum	1
Maximum	30
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	239.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	4
95-th percentile	6
Maximum	30
Range	29
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.0844052
Coefficient of variation (CV)	0.67946977
Kurtosis	36.161564
Mean	3.0676937
Median Absolute Deviation (MAD)	1
Skewness	4.3402408
Sum	46994
Variance	4.3447449
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=30)

Value	Count	Frequency (%)
3	4684	30.6%
2	4577	29.9%
1	2085	13.6%
4	1934	12.6%
5	777	5.1%
6	527	3.4%
7	387	2.5%
8	84	0.5%
10	67	0.4%
9	44	0.3%
Other values (20)	153	1.0%

Value	Count	Frequency (%)
1	2085	13.6%
2	4577	29.9%
3	4684	30.6%
4	1934	12.6%
5	777	5.1%
6	527	3.4%
7	387	2.5%
8	84	0.5%
9	44	0.3%
10	67	0.4%

Value	Count	Frequency (%)
30	3	< 0.1%
29	8	0.1%
28	1	< 0.1%
27	1	< 0.1%
26	3	< 0.1%
25	1	< 0.1%
24	3	< 0.1%
23	1	< 0.1%
22	2	< 0.1%
21	5	< 0.1%

cancellation_ratio
Real number (ℝ)

High correlation Zeros

Distinct	24
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.083170112

Minimum	0
Maximum	0.99999833
Zeros	14020
Zeros (%)	91.5%
Negative	0
Negative (%)	0.0%
Memory size	239.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.99999
Maximum	0.99999833
Range	0.99999833
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.27539279
Coefficient of variation (CV)	3.311199
Kurtosis	7.144159
Mean	0.083170112
Median Absolute Deviation (MAD)	0
Skewness	3.0215973
Sum	1274.083
Variance	0.07584119
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
0	14020	91.5%
0.9999900001	1250	8.2%
0.9285707653	10	0.1%
0.3055554707	8	0.1%
0.9999983333	6	< 0.1%
0.4999975	4	< 0.1%
0.1666663889	3	< 0.1%
0.3333327778	2	< 0.1%
0.03333332222	1	< 0.1%
0.3333322222	1	< 0.1%
Other values (14)	14	0.1%

Value	Count	Frequency (%)
0	14020	91.5%
0.03333332222	1	< 0.1%
0.06382977365	1	< 0.1%
0.06896549346	1	< 0.1%
0.08333326389	1	< 0.1%
0.09374998535	1	< 0.1%
0.09433960484	1	< 0.1%
0.1111109877	1	< 0.1%
0.1428569388	1	< 0.1%
0.1428570408	1	< 0.1%

Value	Count	Frequency (%)
0.9999983333	6	< 0.1%
0.9999900001	1250	8.2%
0.9285707653	10	0.1%
0.6666644445	1	< 0.1%
0.4999975	4	< 0.1%
0.4285708163	1	< 0.1%
0.3333327778	2	< 0.1%
0.3333322222	1	< 0.1%
0.3055554707	8	0.1%
0.2857138776	1	< 0.1%

Interactions

Correlations

	adr	adults	arrival_date_day_of_month	arrival_date_month	arrival_date_week_number	assigned_room_type	babies	booking_changes	cancellation_ratio	children	customer_type	days_in_waiting_list	deposit_type	distribution_channel	is_repeated_guest	lead_time	market_segment	meal	previous_bookings_not_canceled	previous_cancellations	reservation_status	reserved_room_type	stays_in_week_nights	stays_in_weekend_nights	total_of_special_requests	total_stay
adr	1.000	0.225	-0.018	0.167	0.095	0.342	0.043	0.065	-0.159	0.364	0.080	-0.102	0.239	0.082	0.052	-0.372	0.232	0.154	-0.058	-0.160	0.039	0.375	0.073	0.119	0.096	0.132
adults	0.225	1.000	0.045	0.118	0.118	0.328	0.020	0.017	0.045	0.187	0.086	0.039	0.135	0.066	0.082	0.119	0.156	0.114	0.025	0.012	0.117	0.355	0.053	0.069	0.064	0.070
arrival_date_day_of_month	-0.018	0.045	1.000	0.153	-0.060	0.028	0.000	0.019	0.031	0.027	0.080	0.038	0.101	0.090	0.043	-0.047	0.099	0.075	-0.007	0.031	0.038	0.029	-0.030	0.032	0.030	-0.004
arrival_date_month	0.167	0.118	0.153	1.000	0.826	0.057	0.023	0.024	0.155	0.086	0.104	0.142	0.147	0.095	0.034	0.222	0.153	0.109	0.024	0.047	0.155	0.069	0.070	0.078	0.114	0.082
arrival_date_week_number	0.095	0.118	-0.060	0.826	1.000	0.050	0.019	-0.005	-0.273	0.080	0.115	-0.230	0.150	0.082	0.032	0.211	0.144	0.111	-0.007	-0.272	0.150	0.062	0.073	0.043	0.117	0.074
assigned_room_type	0.342	0.328	0.028	0.057	0.050	1.000	0.079	0.038	0.052	0.485	0.095	0.053	0.268	0.171	0.011	0.106	0.230	0.128	0.000	0.000	0.112	0.881	0.069	0.064	0.101	0.085
babies	0.043	0.020	0.000	0.023	0.019	0.079	1.000	0.049	0.000	0.020	0.000	0.000	0.034	0.054	0.000	0.015	0.058	0.000	0.000	0.000	0.007	0.064	0.000	0.012	0.094	0.019
booking_changes	0.065	0.017	0.019	0.024	-0.005	0.038	0.049	1.000	-0.064	0.044	0.019	-0.068	0.079	0.025	0.000	-0.073	0.055	0.029	0.019	-0.063	0.057	0.042	0.022	0.062	0.056	0.053
cancellation_ratio	-0.159	0.045	0.031	0.155	-0.273	0.052	0.000	-0.064	1.000	0.038	0.105	0.372	0.200	0.114	0.473	0.092	0.171	0.094	0.124	1.000	0.056	0.052	-0.049	-0.103	0.046	-0.096
children	0.364	0.187	0.027	0.086	0.080	0.485	0.020	0.044	0.038	1.000	0.023	0.037	0.143	0.046	0.000	0.081	0.145	0.061	0.000	0.000	0.019	0.495	0.048	0.047	0.079	0.061
customer_type	0.080	0.086	0.080	0.104	0.115	0.095	0.000	0.019	0.105	0.023	1.000	0.135	0.197	0.155	0.235	0.076	0.187	0.077	0.037	0.055	0.082	0.092	0.031	0.032	0.088	0.049
days_in_waiting_list	-0.102	0.039	0.038	0.142	-0.230	0.053	0.000	-0.068	0.372	0.037	0.135	1.000	0.202	0.036	0.000	0.249	0.172	0.146	0.026	0.372	0.051	0.053	0.019	-0.101	0.064	-0.027
deposit_type	0.239	0.135	0.101	0.147	0.150	0.268	0.034	0.079	0.200	0.143	0.197	0.202	1.000	0.122	0.050	0.433	0.571	0.210	0.002	0.020	0.151	0.260	0.152	0.165	0.255	0.208
distribution_channel	0.082	0.066	0.090	0.095	0.082	0.171	0.054	0.025	0.114	0.046	0.155	0.036	0.122	1.000	0.230	0.119	0.716	0.059	0.095	0.066	0.144	0.183	0.088	0.078	0.035	0.084
is_repeated_guest	0.052	0.082	0.043	0.034	0.032	0.011	0.000	0.000	0.473	0.000	0.235	0.000	0.050	0.230	1.000	0.062	0.254	0.026	0.464	0.481	0.066	0.000	0.041	0.030	0.005	0.034
lead_time	-0.372	0.119	-0.047	0.222	0.211	0.106	0.015	-0.073	0.092	0.081	0.076	0.249	0.433	0.119	0.062	1.000	0.294	0.181	-0.048	0.092	0.162	0.109	0.062	-0.136	0.123	-0.028
market_segment	0.232	0.156	0.099	0.153	0.144	0.230	0.058	0.055	0.171	0.145	0.187	0.172	0.571	0.716	0.254	0.294	1.000	0.273	0.086	0.066	0.176	0.241	0.152	0.142	0.211	0.162
meal	0.154	0.114	0.075	0.109	0.111	0.128	0.000	0.029	0.094	0.061	0.077	0.146	0.210	0.059	0.026	0.181	0.273	1.000	0.000	0.000	0.054	0.128	0.066	0.097	0.100	0.055
previous_bookings_not_canceled	-0.058	0.025	-0.007	0.024	-0.007	0.000	0.000	0.019	0.124	0.000	0.037	0.026	0.002	0.095	0.464	-0.048	0.086	0.000	1.000	0.145	0.062	0.000	-0.073	-0.009	0.015	-0.070
previous_cancellations	-0.160	0.012	0.031	0.047	-0.272	0.000	0.000	-0.063	1.000	0.000	0.055	0.372	0.020	0.066	0.481	0.092	0.066	0.000	0.145	1.000	0.014	0.014	-0.051	-0.102	0.000	-0.097
reservation_status	0.039	0.117	0.038	0.155	0.150	0.112	0.007	0.057	0.056	0.019	0.082	0.051	0.151	0.144	0.066	0.162	0.176	0.054	0.062	0.014	1.000	0.046	0.165	0.154	0.102	0.158
reserved_room_type	0.375	0.355	0.029	0.069	0.062	0.881	0.064	0.042	0.052	0.495	0.092	0.053	0.260	0.183	0.000	0.109	0.241	0.128	0.000	0.014	0.046	1.000	0.080	0.069	0.099	0.096
stays_in_week_nights	0.073	0.053	-0.030	0.070	0.073	0.069	0.000	0.022	-0.049	0.048	0.031	0.019	0.152	0.088	0.041	0.062	0.152	0.066	-0.073	-0.051	0.165	0.080	1.000	0.017	0.051	0.787
stays_in_weekend_nights	0.119	0.069	0.032	0.078	0.043	0.064	0.012	0.062	-0.103	0.047	0.032	-0.101	0.165	0.078	0.030	-0.136	0.142	0.097	-0.009	-0.102	0.154	0.069	0.017	1.000	0.059	0.575
total_of_special_requests	0.096	0.064	0.030	0.114	0.117	0.101	0.094	0.056	0.046	0.079	0.088	0.064	0.255	0.035	0.005	0.123	0.211	0.100	0.015	0.000	0.102	0.099	0.051	0.059	1.000	0.074
total_stay	0.132	0.070	-0.004	0.082	0.074	0.085	0.019	0.053	-0.096	0.061	0.049	-0.027	0.208	0.084	0.034	-0.028	0.162	0.055	-0.070	-0.097	0.158	0.096	0.787	0.575	0.074	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

	hotel	is_canceled	lead_time	arrival_date_year	arrival_date_month	arrival_date_week_number	arrival_date_day_of_month	stays_in_weekend_nights	stays_in_week_nights	adults	children	meal	country	market_segment	distribution_channel	reserved_room_type	assigned_room_type	deposit_type	customer_type	adr	total_of_special_requests	reservation_status	reservation_status_date	total_stay
4	City Hotel	1	31	2016	April	17	23	2	4	2	1	BB	PRT	Offline TA/TO	TA/TO	D	D	No Deposit	Transient	26.35	0	Canceled	23/03/2016	6
30	City Hotel	1	12	2016	March	14	28	1	2	2	0	BB	PRT	Offline TA/TO	TA/TO	A	A	No Deposit	Transient	38.67	0	No-Show	28/03/2016	3
85	City Hotel	1	60	2016	April	15	9	2	3	3	0	BB	PRT	Offline TA/TO	TA/TO	A	B	No Deposit	Transient	41.76	1	No-Show	09/04/2016	5
92	City Hotel	1	16	2016	January	6	31	2	2	1	0	BB	PRT	Offline TA/TO	TA/TO	A	A	No Deposit	Transient	43.00	0	No-Show	31/01/2016	4
108	City Hotel	1	0	2016	April	15	3	2	1	2	0	BB	FRA	Online TA	TA/TO	D	D	No Deposit	Transient-Party	44.60	0	Canceled	03/04/2016	3
112	City Hotel	1	0	2016	April	18	28	0	1	1	0	BB	PRT	Offline TA/TO	TA/TO	A	D	No Deposit	Transient-Party	45.00	2	Canceled	28/04/2016	1
113	City Hotel	1	0	2016	July	31	27	0	1	1	0	BB	PRT	Offline TA/TO	TA/TO	A	A	No Deposit	Transient	45.00	1	Canceled	27/07/2016	1
114	City Hotel	1	0	2016	July	31	27	0	1	1	0	BB	PRT	Offline TA/TO	TA/TO	A	A	No Deposit	Transient	45.00	1	Canceled	27/07/2016	1
115	City Hotel	1	0	2016	October	44	28	0	1	1	0	BB	PRT	Offline TA/TO	TA/TO	A	A	No Deposit	Transient	45.00	1	No-Show	28/10/2016	1
153	City Hotel	1	54	2016	March	10	1	0	4	2	0	SC	PRT	Online TA	TA/TO	A	A	No Deposit	Transient	47.43	0	Canceled	07/01/2016	4

	hotel	is_canceled	lead_time	arrival_date_year	arrival_date_month	arrival_date_week_number	arrival_date_day_of_month	stays_in_weekend_nights	stays_in_week_nights	adults	children	meal	country	market_segment	distribution_channel	reserved_room_type	assigned_room_type	booking_changes	deposit_type	customer_type	adr	total_of_special_requests	reservation_status	reservation_status_date	total_stay
37462	City Hotel	1	36	2016	July	31	27	1	4	2	2	BB	PRT	Online TA	TA/TO	G	G	0	No Deposit	Transient	278.90	0	Canceled	22/06/2016	5
37463	City Hotel	1	29	2016	September	40	28	1	4	1	0	BB	PRT	Online TA	TA/TO	G	G	2	No Deposit	Transient	279.20	1	Canceled	28/09/2016	5
37465	City Hotel	1	0	2016	August	34	16	0	1	2	2	BB	PRT	Direct	Direct	F	F	0	No Deposit	Transient	283.00	3	No-Show	16/08/2016	1
37467	City Hotel	1	22	2016	September	38	17	0	1	1	2	BB	EGY	Online TA	TA/TO	B	B	0	No Deposit	Transient	284.10	0	Canceled	26/08/2016	1
37469	City Hotel	1	24	2016	May	21	21	2	1	3	1	BB	PRT	Online TA	TA/TO	G	G	0	No Deposit	Transient	285.17	0	Canceled	03/05/2016	3
37470	City Hotel	1	24	2016	May	21	21	2	1	3	1	BB	PRT	Online TA	TA/TO	G	G	0	No Deposit	Transient	285.17	0	Canceled	03/05/2016	3
37472	City Hotel	1	22	2016	August	34	19	0	2	2	2	HB	ESP	Online TA	TA/TO	F	F	0	No Deposit	Transient	288.00	2	Canceled	02/08/2016	2
37474	City Hotel	1	26	2016	October	40	1	2	2	2	2	HB	BEL	Online TA	TA/TO	F	F	0	No Deposit	Transient	294.00	2	Canceled	16/09/2016	4
37479	City Hotel	1	21	2016	July	30	17	2	1	4	0	BB	PRT	Online TA	TA/TO	G	G	0	No Deposit	Transient	299.33	0	Canceled	07/07/2016	3
37485	City Hotel	1	11	2016	September	38	16	1	2	2	2	HB	FRA	Online TA	TA/TO	F	F	0	No Deposit	Transient	306.00	0	Canceled	08/09/2016	3

Duplicate rows

Most frequently occurring

	hotel	is_canceled	lead_time	arrival_date_year	arrival_date_month	arrival_date_week_number	arrival_date_day_of_month	stays_in_weekend_nights	stays_in_week_nights	adults	meal	country	market_segment	distribution_channel	previous_cancellations	reserved_room_type	assigned_room_type	deposit_type	days_in_waiting_list	customer_type	adr	reservation_status	reservation_status_date	total_stay	cancellation_ratio	# duplicates
914	City Hotel	1	277	2016	November	46	7	1	2	2	BB	PRT	Groups	TA/TO	0	A	A	Non Refund	0	Transient	100.0	Canceled	04/04/2016	3	0.00000	180
348	City Hotel	1	68	2016	February	8	17	0	2	2	BB	PRT	Groups	TA/TO	1	A	A	Non Refund	0	Transient	75.0	Canceled	06/01/2016	2	0.99999	150
757	City Hotel	1	188	2016	June	25	15	0	2	1	BB	PRT	Offline TA/TO	TA/TO	0	A	A	Non Refund	39	Transient	130.0	Canceled	18/01/2016	2	0.00000	109
665	City Hotel	1	158	2016	May	22	24	0	2	1	BB	PRT	Groups	TA/TO	0	A	A	Non Refund	31	Transient	130.0	Canceled	18/01/2016	2	0.00000	101
360	City Hotel	1	71	2016	June	25	14	0	3	1	BB	PRT	Offline TA/TO	TA/TO	0	A	A	Non Refund	0	Transient	120.0	Canceled	27/04/2016	3	0.00000	89
693	City Hotel	1	166	2016	November	45	1	0	3	1	BB	PRT	Offline TA/TO	TA/TO	0	A	A	Non Refund	0	Transient	110.0	Canceled	13/07/2016	3	0.00000	85
955	City Hotel	1	304	2016	November	45	3	0	3	2	BB	PRT	Offline TA/TO	TA/TO	0	A	A	Non Refund	0	Transient	89.0	Canceled	01/02/2016	3	0.00000	85
956	City Hotel	1	305	2016	November	45	4	1	2	2	BB	PRT	Offline TA/TO	TA/TO	0	A	A	Non Refund	0	Transient	89.0	Canceled	01/02/2016	3	0.00000	85
217	City Hotel	1	37	2016	October	42	13	0	3	2	BB	PRT	Offline TA/TO	TA/TO	0	A	A	No Deposit	0	Transient-Party	105.0	Canceled	06/09/2016	3	0.00000	84
474	City Hotel	1	99	2016	February	8	19	0	1	2	BB	PRT	Corporate	Corporate	1	A	A	No Deposit	0	Transient-Party	80.0	Canceled	22/12/2015	1	0.99999	69

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values